/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50542
 Source Host           : localhost
 Source Database       : gulbagh

 Target Server Type    : MySQL
 Target Server Version : 50542
 File Encoding         : utf-8

 Date: 09/17/2015 17:27:12 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `sch_access`
-- ----------------------------
DROP TABLE IF EXISTS `sch_access`;
CREATE TABLE `sch_access` (
  `role_id` int(10) NOT NULL,
  `node_id` int(10) NOT NULL,
  `level` int(11) NOT NULL,
  `module` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sch_access`
-- ----------------------------
BEGIN;
INSERT INTO `sch_access` VALUES ('1', '2', '1', null), ('1', '3', '2', null), ('1', '13', '3', null), ('1', '14', '3', null), ('1', '15', '3', null), ('1', '16', '3', null), ('1', '17', '3', null), ('1', '18', '3', null), ('1', '19', '3', null), ('1', '20', '3', null), ('1', '12', '3', null), ('1', '11', '3', null), ('1', '4', '3', null), ('1', '5', '3', null), ('1', '6', '3', null), ('1', '7', '3', null), ('1', '8', '3', null), ('1', '9', '3', null), ('1', '10', '3', null), ('1', '21', '3', null), ('3', '18', '3', null), ('3', '19', '3', null), ('3', '3', '2', null), ('3', '2', '1', null), ('11', '27', '1', null), ('4', '21', '3', null), ('4', '4', '3', null), ('4', '5', '3', null), ('4', '6', '3', null), ('4', '7', '3', null), ('4', '9', '3', null), ('4', '11', '3', null), ('4', '13', '3', null), ('4', '3', '2', null), ('4', '2', '1', null), ('3', '17', '3', null), ('3', '16', '3', null), ('3', '15', '3', null), ('3', '7', '3', null), ('3', '6', '3', null), ('3', '5', '3', null), ('3', '4', '3', null), ('3', '21', '3', null), ('11', '28', '2', null), ('11', '31', '3', null), ('11', '32', '3', null), ('11', '33', '3', null), ('11', '34', '3', null), ('11', '35', '3', null), ('11', '36', '3', null), ('11', '37', '3', null), ('11', '38', '3', null), ('11', '39', '3', null), ('11', '40', '3', null), ('11', '41', '3', null), ('11', '42', '3', null), ('11', '29', '3', null), ('11', '30', '3', null), ('11', '44', '2', null), ('31', '95', '3', null), ('31', '86', '3', null), ('31', '85', '2', null), ('31', '49', '1', null), ('10', '64', '3', null), ('10', '107', '3', null), ('10', '63', '2', null), ('10', '62', '3', null), ('10', '61', '3', null), ('10', '60', '2', null), ('10', '99', '3', null), ('10', '98', '3', null), ('10', '56', '3', null), ('10', '55', '3', null), ('10', '54', '3', null), ('10', '53', '3', null), ('10', '52', '3', null), ('10', '51', '3', null), ('10', '93', '3', null), ('10', '50', '2', null), ('10', '67', '3', null), ('10', '68', '3', null), ('10', '71', '3', null), ('10', '70', '3', null), ('10', '69', '3', null), ('10', '66', '2', null), ('10', '108', '3', null), ('10', '83', '3', null), ('10', '82', '3', null), ('10', '81', '2', null), ('10', '77', '3', null), ('10', '76', '3', null), ('17', '62', '3', null), ('17', '61', '3', null), ('17', '60', '2', null), ('17', '49', '1', null), ('16', '64', '3', null), ('16', '65', '3', null), ('15', '65', '3', null), ('15', '63', '2', null), ('15', '62', '3', null), ('13', '69', '3', null), ('13', '68', '3', null), ('13', '66', '2', null), ('13', '95', '3', null), ('13', '86', '3', null), ('13', '85', '2', null), ('13', '49', '1', null), ('14', '83', '3', null), ('14', '82', '3', null), ('14', '81', '2', null), ('14', '49', '1', null), ('15', '61', '3', null), ('15', '60', '2', null), ('15', '59', '3', null), ('15', '58', '3', null), ('15', '57', '2', null), ('15', '56', '3', null), ('15', '55', '3', null), ('15', '54', '3', null), ('15', '53', '3', null), ('15', '52', '3', null), ('15', '51', '3', null), ('15', '50', '2', null), ('15', '88', '3', null), ('15', '87', '3', null), ('15', '86', '3', null), ('15', '85', '2', null), ('15', '49', '1', null), ('16', '63', '2', null), ('14', '90', '3', null), ('14', '89', '3', null), ('15', '64', '3', null), ('20', '59', '3', null), ('16', '49', '1', null), ('18', '87', '3', null), ('18', '86', '3', null), ('18', '85', '2', null), ('18', '49', '1', null), ('19', '77', '3', null), ('19', '76', '3', null), ('19', '75', '2', null), ('19', '49', '1', null), ('0', '49', '1', null), ('21', '49', '1', null), ('0', '63', '2', null), ('0', '65', '3', null), ('0', '64', '3', null), ('20', '58', '3', null), ('20', '57', '2', null), ('20', '49', '1', null), ('18', '88', '3', null), ('10', '75', '2', null), ('10', '95', '3', null), ('10', '86', '3', null), ('10', '85', '2', null), ('10', '49', '1', null), ('27', '49', '1', null), ('27', '85', '2', null), ('27', '86', '3', null), ('27', '87', '3', null), ('27', '88', '3', null), ('27', '95', '3', null), ('27', '75', '2', null), ('27', '76', '3', null), ('27', '77', '3', null), ('27', '81', '2', null), ('27', '82', '3', null), ('27', '83', '3', null), ('27', '89', '3', null), ('27', '90', '3', null), ('27', '66', '2', null), ('27', '69', '3', null), ('27', '70', '3', null), ('27', '71', '3', null), ('27', '68', '3', null), ('27', '67', '3', null), ('27', '50', '2', null), ('27', '93', '3', null), ('27', '51', '3', null), ('27', '52', '3', null), ('27', '53', '3', null), ('27', '54', '3', null), ('27', '55', '3', null), ('27', '56', '3', null), ('27', '98', '3', null), ('27', '99', '3', null), ('27', '100', '3', null), ('27', '60', '2', null), ('27', '61', '3', null), ('27', '62', '3', null), ('27', '63', '2', null), ('27', '64', '3', null), ('27', '65', '3', null), ('21', '67', '3', null), ('21', '66', '2', null), ('13', '67', '3', null), ('13', '71', '3', null), ('13', '70', '3', null), ('28', '67', '3', null), ('28', '68', '3', null), ('28', '71', '3', null), ('28', '70', '3', null), ('28', '69', '3', null), ('28', '66', '2', null), ('28', '65', '3', null), ('28', '64', '3', null), ('28', '63', '2', null), ('28', '62', '3', null), ('28', '61', '3', null), ('28', '60', '2', null), ('28', '99', '3', null), ('28', '98', '3', null), ('28', '56', '3', null), ('28', '55', '3', null), ('28', '54', '3', null), ('28', '53', '3', null), ('28', '52', '3', null), ('28', '51', '3', null), ('28', '93', '3', null), ('28', '50', '2', null), ('28', '90', '3', null), ('28', '89', '3', null), ('28', '83', '3', null), ('28', '82', '3', null), ('28', '81', '2', null), ('28', '77', '3', null), ('28', '76', '3', null), ('28', '75', '2', null), ('28', '49', '1', null);
COMMIT;

-- ----------------------------
--  Table structure for `sch_category`
-- ----------------------------
DROP TABLE IF EXISTS `sch_category`;
CREATE TABLE `sch_category` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(110) DEFAULT NULL,
  `sort` int(10) DEFAULT NULL,
  `pid` int(10) DEFAULT NULL,
  `en_name` varchar(110) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=239 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `sch_category`
-- ----------------------------
BEGIN;
INSERT INTO `sch_category` VALUES ('24', '办公室通知', '4', '10', 'ban_gong_shi_tong_zhi'), ('10', '校务公开', '1', '0', 'xiao_wu_gong_kai'), ('22', '机构设置', '2', '10', 'ji_gou_she_zhi'), ('19', '学校概况', '1', '10', 'xue_xiao_gai_kuang'), ('11', '教育教学', '2', '0', 'jiao_yu_jiao_xue'), ('12', '党建工作', '3', '0', 'dang_jian_gong_zuo'), ('13', '德育之窗', '4', '0', 'de_yu_zhi_chuang'), ('14', '安全生产', '5', '0', 'an_quan_sheng_chan'), ('224', '校务公开', '5', '10', 'xiao_wu_gong_kai'), ('16', '师生园地', '8', '0', 'shi_sheng_yuan_di'), ('208', '家校互动', '6', '0', 'jia_xiao_hu_dong'), ('23', '文件通知', '3', '10', 'wen_jian_tong_zhi'), ('228', '最新动态', '0', '0', 'zui_xin_dong_tai'), ('26', '党务公开', '6', '10', 'dang_wu_gong_kai'), ('27', '财务公开', '7', '10', 'sai_wu_gong_kai'), ('28', '发展规划', '8', '10', 'fa_zhan_gui_hua'), ('29', '学校荣誉', '9', '10', 'xue_xiao_rong_yu'), ('30', '学校标语', '11', '10', 'xuo_xiao_biao_yu'), ('31', '校园信息', '12', '10', 'xiao_yuan_xin_xi'), ('32', '学校宣传栏', '10', '10', 'xue_xiao_xuan_chuan_lan'), ('229', '网站公告', '100', '228', 'wang_zhan_gong_gao'), ('34', '周工作安排', '1', '11', 'zhou_gong_zuo_an_pai'), ('35', '教研活动', '2', '11', 'jiao_yan_huo_dong'), ('36', '双语教育', '3', '11', 'shuang_yu_jiao_yu'), ('37', '实验教学', '4', '11', 'shi_yan_shu_xue'), ('39', '阳光体育', '8', '11', 'yang_guang_ti_yu'), ('40', '教学常规', '9', '11', 'jiao_xue_chang_gui'), ('41', '考试安排', '10', '11', 'kao_shi_an_pai'), ('43', '课题研究', '11', '11', 'ke_ti_yan_jiu'), ('44', '党建工作', '1', '12', 'dang_jian_gong_zuo'), ('45', '团活动', '2', '12', 'tuan_huo_dong'), ('46', '工会之家', '3', '12', 'gong_hui_zhi_jia'), ('47', '思想政治工作', '4', '12', 'xiang_si_jing_ji_gong_zuo'), ('48', '妇联工作', '5', '12', 'fu_lian_gong_zuo'), ('49', '主题教育', '7', '12', 'zhu_ti_jiao_yu'), ('52', '党风廉政', '6', '12', 'dang_feng_lian_zheng'), ('51', '德育建设', '1', '13', 'de_yu-jian_she'), ('53', '学生会工作', '2', '13', 'xuo_sheng_hui_gong_zuo'), ('54', '心理健康工作', '3', '13', 'xin_li_jian_kang_gong_zuo'), ('55', '家庭教育工作', '4', '13', 'jia_ting_jiao_yu_gong_zuo'), ('56', '师德师风工作', '5', '13', 'shi-de_shi_feng_gong_zuo'), ('57', '德育科研', '6', '13', 'de_yu_ke_yan'), ('58', '民族团结工作', '7', '13', 'min-zu_tuan_jie_gong_zuo'), ('59', '安全工作', '1', '14', 'an_quan_gong_zuo'), ('60', '健康教育', '2', '14', 'jian_kang_jiao_yu'), ('61', '应急预案', '3', '14', 'jing_ji_yu_an'), ('62', '校园安全', '4', '14', 'xiao_yuan_an_quan'), ('63', '食品安全', '5', '14', 'shi_pin_an_quan'), ('64', '卫生教育', '6', '14', 'wei_sheng_jiao_yu'), ('230', '幻灯片', '100', '228', 'huan_deng_pian'), ('70', '教师风采', '1', '16', 'jiao_shi_feng_cai'), ('71', '学生风采', '2', '16', 'xue_sheng_feng_cai'), ('72', '师生作品', '3', '16', 'shi_sheng_zuo_pin'), ('73', '三好学生', '4', '16', 'san_hao_xue_sheng'), ('74', '优秀教师', '5', '16', 'you_xiu_jiao_shi'), ('209', '资源中心', '7', '0', 'zi_yuan_zhong_xin'), ('210', '各学科教育', '100', '209', 'ge_xue_ke_jiao_yu'), ('211', '课件共享', '100', '209', 'ke_jian_gong_xiang'), ('212', '教案共享', '100', '209', 'jiao_an_gong_xiang'), ('213', '试卷共享', '100', '209', 'shi_zhuan_gong_xiang'), ('214', '校园视频', '100', '209', 'xiao_yuan_shhi_pin'), ('215', '资源网站', '100', '209', 'zi_yuan_wang_zhan'), ('217', '在线办事', '1', '208', 'zai_xian_ban_shi'), ('218', '校长信箱', '2', '208', 'xiao_zhang_xin_xiang'), ('219', '书记信箱', '3', '208', 'shu_ji_xin_xiang'), ('220', '成绩查询', '4', '208', 'cheng_ji_cha_xun'), ('221', '远程教育', '5', '11', 'yuan_cheng_jiao_yu'), ('222', '第二课堂活动', '6', '11', 'di_er_ke_tang_huou_dong'), ('223', '课外活动', '7', '11', 'ke_wai_huo_dong');
COMMIT;

-- ----------------------------
--  Table structure for `sch_content`
-- ----------------------------
DROP TABLE IF EXISTS `sch_content`;
CREATE TABLE `sch_content` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `con_title` varchar(250) DEFAULT NULL,
  `con_content` text,
  `con_category` varchar(210) DEFAULT NULL,
  `con_pic` varchar(250) DEFAULT NULL,
  `con_file` varchar(2500) DEFAULT NULL,
  `add_time` varchar(20) DEFAULT NULL,
  `adder_ip` varchar(255) DEFAULT NULL,
  `con_file_name` varchar(200) DEFAULT NULL,
  `con_video` varchar(2500) DEFAULT NULL,
  `adder_name` varchar(220) DEFAULT NULL,
  `accept` tinyint(1) DEFAULT '0',
  `video_old_name` varchar(2500) DEFAULT NULL,
  `file_old_name` varchar(2500) DEFAULT NULL,
  `count` int(10) DEFAULT '0',
  `security` int(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=430 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `sch_content`
-- ----------------------------
BEGIN;
INSERT INTO `sch_content` VALUES ('408', 'alim', '', 'ban_gong_shi_tong_zhi', null, '0', '2015-09-17', '0.0.0.0', null, '0', 'ghulam', '1', '0', '0', '0', '0'), ('409', 'arettgryrtutyutyurtyuty', '', 'ban_gong_shi_tong_zhi', null, '0', '2015-09-17', '0.0.0.0', null, '0', 'ghulam', '1', '0', '0', '0', '0'), ('412', 'gdfgdfgfd43534546456', '<p>gdfgdfgfd</p>', 'xue_xiao_gai_kuang', null, '0', '2015-09-17', '0.0.0.0', null, '0', 'ghulam', '1', '0', '0', '0', '0'), ('413', 'xue_xiao_gai_kuang', '&lt;p&gt;hfghfghgf&lt;/p&gt;', 'xue_xiao_gai_kuang', null, '0', '2015-09-17', '0.0.0.0', '', '0', 'ghulam', '1', '0', '0', '0', '0'), ('415', 'fsadfsdfsdfsda', '', 'huan_deng_pian', 'th55fa9f5a31df3.jpg', '0', '2015-09-17', '0.0.0.0', null, '0', 'ghulam', '1', '0', '0', '0', '0'), ('416', 'fsdafasdfasdf', '', 'huan_deng_pian', 'th55fa9f627c4d6.jpg', '0', '2015-09-17', '0.0.0.0', null, '0', 'ghulam', '1', '0', '0', '0', '0'), ('417', 'fsadfasdfasdfdsa', '', 'huan_deng_pian', 'th55fa9f6a76f31.jpg', '0', '2015-09-17', '0.0.0.0', null, '0', 'ghulam', '1', '0', '0', '0', '0'), ('418', 'fsdfsdfsdfgsdfgd', '', 'huan_deng_pian', 'th55fa9f77a55b0.jpg', '0', '2015-09-17', '0.0.0.0', null, '0', 'ghulam', '1', '0', '0', '0', '0'), ('423', '123534645656', '', 'wang_zhan_gong_gao', null, '0', '2015-09-17', '0.0.0.0', null, 'gulbagh/uploads/video/2015-09-17/55fa9e0311474.mp4,gulbagh/uploads/video/2015-09-17/55fa9e013e2f1.mp4,gulbagh/uploads/video/2015-09-17/55fa9e00447d4.mp4', 'ghulam', '1', 'XMjcwNzEyMTg4.mp4,XMjcwNzEyMjY0.mp4,XMjcwNzEyMDM2.mp4', '0', '1', '0'), ('425', 'gdfgfdg', '', 'you_xiu_jiao_shi', null, '0', '2015-09-17', '0.0.0.0', '', '0', 'ghulam', '0', '0', '0', '0', '0'), ('426', '222', '', 'wang_zhan_gong_gao', null, '0', '2015-09-17', '0.0.0.0', null, '0', 'ghulam', '1', '0', '0', '0', '0'), ('407', '121212121212121212', '<p>gfgfdgfdgfdfgdsdsdfsfdsdfsfgsfdsfdsfdsdfdsfdsfd</p>', 'ban_gong_shi_tong_zhi', 'th55fa35930a0fc.jpg', '0', '2015-09-17', '0.0.0.0', null, '0', 'ghulam', '1', '0', '0', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `sch_link`
-- ----------------------------
DROP TABLE IF EXISTS `sch_link`;
CREATE TABLE `sch_link` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL,
  `lin_url` varchar(250) DEFAULT NULL,
  `lin_img` varchar(110) DEFAULT NULL,
  `lin_sort` int(10) DEFAULT NULL,
  `adder_ip` varchar(20) DEFAULT NULL,
  `adder_name` varchar(20) DEFAULT NULL,
  `add_time` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=152 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `sch_link`
-- ----------------------------
BEGIN;
INSERT INTO `sch_link` VALUES ('138', '百度', 'http://www.baidu.com', 'th55ed4c4ce69ee.jpg', '1', '0.0.0.0', 'admin', '2015-09-07'), ('139', 'okyan', 'http://www.okyan.com', 'th55ed739476b99.jpg', '2', '0.0.0.0', 'admin', '2015-09-07'), ('140', 'http://www.okyan.com', 'http://www.okyan.com', 'th55ed73a760766.jpg', '3', '0.0.0.0', 'admin', '2015-09-07'), ('141', 'http://www.okyan.com', 'http://www.okyan.com', 'th55ed73bf8d0c2.jpg', '4', '0.0.0.0', 'admin', '2015-09-07'), ('142', 'http://www.okyan.com', 'http://www.okyan.com', 'th55ed73cb66478.jpg', '5', '0.0.0.0', 'admin', '2015-09-07'), ('143', 'http://www.okyan.com', 'http://www.okyan.com', 'th55ed73dd0e25b.jpg', '6', '0.0.0.0', 'admin', '2015-09-07'), ('144', 'http://www.okyan.com', 'http://www.okyan.com', 'th55ed7449b767f.jpg', '8', '0.0.0.0', 'admin', '2015-09-07'), ('145', 'http://www.okyan.com', 'http://www.okyan.com', 'th55ed745a45d0d.jpg', '9', '0.0.0.0', 'admin', '2015-09-07'), ('146', 'http://www.okyan.com', 'http://www.okyan.com', 'th55ed74655cb05.jpg', '0', '0.0.0.0', 'admin', '2015-09-07'), ('147', 'http://www.okyan.com', 'http://www.okyan.com', 'th55ed7474a04e8.jpg', '76', '0.0.0.0', 'admin', '2015-09-07'), ('148', 'http://www.okyan.com', 'http://www.okyan.com', 'th55ed747f83abf.jpg', '456', '0.0.0.0', 'admin', '2015-09-07'), ('149', 'http://www.okyan.com', 'http://www.okyan.com', 'th55ed748caaef9.jpg', '543', '0.0.0.0', 'admin', '2015-09-07'), ('150', 'http://www.okyan.com', 'http://www.okyan.com', 'th55ed749bbb16a.jpg', '9', '0.0.0.0', 'admin', '2015-09-07');
COMMIT;

-- ----------------------------
--  Table structure for `sch_member`
-- ----------------------------
DROP TABLE IF EXISTS `sch_member`;
CREATE TABLE `sch_member` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `mem_number` bigint(11) NOT NULL,
  `mem_name` varchar(200) NOT NULL,
  `mem_email` varchar(100) DEFAULT NULL,
  `mem_phone` varchar(20) DEFAULT NULL,
  `mem_password` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `mem_status` int(1) DEFAULT '0',
  `logintime` varchar(30) DEFAULT NULL,
  `loginip` varchar(30) DEFAULT NULL,
  `lock` int(1) NOT NULL DEFAULT '0',
  `real_name` varchar(100) DEFAULT NULL,
  `reg_time` char(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=80 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `sch_member`
-- ----------------------------
BEGIN;
INSERT INTO `sch_member` VALUES ('71', '12', 'alim', 'awdfsd@eqwew.jkj', 'asadasdasdas', 'e10adc3949ba59abbe56e057f20f883e', '1', '1441958553', '0.0.0.0', '1', '阿丽米艾海涛', null), ('72', '0', '', '', '', 'd41d8cd98f00b204e9800998ecf8427e', '0', null, null, '0', null, null), ('73', '123', 'abdulla', 'qwertyuiop@qq.ghg', '123456789012', 'e10adc3949ba59abbe56e057f20f883e', '0', null, null, '0', '阿卜杜拉', null), ('74', '2', '21', '21212@ww.com', '2', 'c81e728d9d4c2f636f067f89cc14862c', '0', null, null, '1', '12', '2015-09-09-04:59:06'), ('75', '123', 'alimjan', '21212@ww.com', '212121212', 'f7d211ec7e6ee5eee661f6978bbd22a4', '1', '1441789294', '0.0.0.0', '1', '阿里木江', '2015-09-09-05:00:33'), ('76', '234354356346456', 'a', '222216453', '15709917364', '0cc175b9c0f1b6a831c399e269772661', '1', '1442394456', '0.0.0.0', '1', 'a', '2015-09-12-01:57:38'), ('77', '12', 'abdulla2', '2121', '212', 'ace613b0a092b2a77e48013707f27e8e', '1', null, null, '1', 'abdulla2', '2015-09-14-10:15:54'), ('78', '123', '太热', '1', '15709917364', 'c4ca4238a0b923820dcc509a6f75849b', '0', null, null, '1', '尔特让他', '2015-09-14-04:10:51'), ('79', '11', '11', '11', '11', '6512bd43d9caa6e02c990b0a82652dca', '0', null, null, '1', '11', '2015-09-14-05:23:12');
COMMIT;

-- ----------------------------
--  Table structure for `sch_message`
-- ----------------------------
DROP TABLE IF EXISTS `sch_message`;
CREATE TABLE `sch_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ask_content` text,
  `mes_replay` text,
  `ask_ip` varchar(20) DEFAULT NULL,
  `replayer_name` varchar(110) DEFAULT NULL,
  `replayer_ip` varchar(20) DEFAULT NULL,
  `ask_time` varchar(30) DEFAULT NULL,
  `replay_time` char(100) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `sch_message`
-- ----------------------------
BEGIN;
INSERT INTO `sch_message` VALUES ('136', '撒旦的', '啊实打实大苏打', null, 'admin', '0.0.0.0', '2015-09-02', '2015-09-02', '1'), ('137', '恶趣味完全', '故意贴图', null, 'admin', '0.0.0.0', '2015-09-02', '2015-09-02', '1'), ('138', 'dsfdgdsfggdfgdfg', 'gdfgdfg', '0.0.0.0', 'admin', '0.0.0.0', '2015-09-03', '2015-09-03', '1'), ('139', 'gdfsgdsfgsdfg', 'gdfgdf', '0.0.0.0', 'admin', '0.0.0.0', '2015-09-03', '2015-09-03', '1'), ('140', 'gdfgsdfgdsfg', 'gdfgdfg', '0.0.0.0', 'admin', '0.0.0.0', '2015-09-03', '2015-09-03', '1'), ('141', 'gdfgd', 'gdfgdfg', '0.0.0.0', 'admin', '0.0.0.0', '2015-09-03', '2015-09-03', '1'), ('143', 'yuiyuiyuiuy', 'ui645364645754756756757567547457', '0.0.0.0', 'ghulam', '0.0.0.0', '2015-09-11', '2015-09-11', '1'), ('145', 'sinaq sual', 'jawab', '0.0.0.0', 'ghulam', '0.0.0.0', '2015-09-12', '2015-09-12', '1'), ('146', 'gfhgfh', 'gfhfghfgh', null, 'ghulam', '0.0.0.0', '2015-09-12', '2015-09-12', '1'), ('148', '1234567890-=1234567890-1234567890-1234567890-1234567890-', '=-0987654321`=-09876543=-0987654321`=-098765432=-09876543', '0.0.0.0', 'ghulam', '0.0.0.0', '2015-09-16', '2015-09-16', '1'), ('150', 'hgfhgf', 'hgfhfgh', null, 'ghulam', '0.0.0.0', '2015-09-16', '2015-09-16', '1'), ('151', 'ut8g', 'kygu', null, 'ghulam', '0.0.0.0', '2015-09-17', '2015-09-17', '1'), ('152', '1', '2', '0.0.0.0', 'ghulam', '0.0.0.0', '2015-09-17', '2015-09-17', '1');
COMMIT;

-- ----------------------------
--  Table structure for `sch_node`
-- ----------------------------
DROP TABLE IF EXISTS `sch_node`;
CREATE TABLE `sch_node` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `status` int(10) DEFAULT NULL,
  `remark` varchar(250) DEFAULT NULL,
  `sort` int(10) DEFAULT NULL,
  `pid` int(10) NOT NULL,
  `level` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=109 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sch_node`
-- ----------------------------
BEGIN;
INSERT INTO `sch_node` VALUES ('49', 'Admin', '后台管理', '1', null, '1', '0', '1'), ('50', 'Rbac', '系统管理', '1', null, '1', '49', '2'), ('51', 'role', '角色列表', '1', null, '1', '50', '3'), ('52', 'addRole', '添加角色', '1', null, '1', '50', '3'), ('53', 'node', '权限列表', '1', null, '1', '50', '3'), ('54', 'addNode', '添加权限', '1', null, '1', '50', '3'), ('55', 'email', '邮箱设置', '1', null, '1', '50', '3'), ('56', 'sestem', '网站信息', '1', null, '1', '50', '3'), ('98', 'index', '管理员列表', '1', null, '1', '50', '3'), ('99', 'addUser', '添加管理员', '1', null, '1', '50', '3'), ('60', 'Member', '会员管理', '1', null, '1', '49', '2'), ('61', 'index', '会员列表', '1', null, '1', '60', '3'), ('62', 'addmember', '添加会员', '1', null, '1', '60', '3'), ('63', 'Category', '栏目管理', '1', null, '1', '49', '2'), ('64', 'index', '栏目列表', '1', null, '1', '63', '3'), ('66', 'Content', '内容管理', '1', null, '1', '49', '2'), ('67', 'index', '查看内容列表', '1', null, '1', '66', '3'), ('68', 'addcontent', '添加内容', '1', null, '1', '66', '3'), ('69', 'on_status', '审核内容', '1', null, '1', '66', '3'), ('70', 'edit', '编辑内容', '1', null, '1', '66', '3'), ('71', 'delete', '删除内容', '1', null, '1', '66', '3'), ('85', 'Link', '友情链接管理', '1', null, '1', '49', '2'), ('86', 'index', '查看友情链接列表', '1', null, '1', '85', '3'), ('75', 'Excel', '成绩管理', '1', null, '1', '49', '2'), ('76', 'index', '导入成绩表', '1', null, '1', '75', '3'), ('77', 'see', '查看成绩', '1', null, '1', '75', '3'), ('81', 'Replay', '留言管理', '1', null, '1', '49', '2'), ('82', 'show', '进入答案页面', '1', null, '1', '81', '3'), ('83', 'index', '进入留言页面', '1', null, '1', '81', '3'), ('107', 'addcategory', '添加栏目', '1', null, '1', '63', '3'), ('108', 'add', '添加问答', '1', null, '1', '81', '3'), ('93', 'school_masters', '校长信息与书记信息', '1', null, '1', '50', '3'), ('95', 'addlink', '添加友情链接', '1', null, '1', '85', '3');
COMMIT;

-- ----------------------------
--  Table structure for `sch_result_db`
-- ----------------------------
DROP TABLE IF EXISTS `sch_result_db`;
CREATE TABLE `sch_result_db` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_number` varchar(64) DEFAULT NULL,
  `test_number` varchar(64) DEFAULT NULL,
  `class` varchar(64) DEFAULT NULL,
  `student_name` varchar(64) DEFAULT NULL,
  `math_num` varchar(64) DEFAULT NULL,
  `language_num` varchar(64) DEFAULT NULL,
  `chines_num` varchar(64) DEFAULT NULL,
  `politics_num` varchar(64) DEFAULT NULL,
  `history_num` varchar(64) DEFAULT NULL,
  `geography_num` varchar(64) DEFAULT NULL,
  `biology_num` varchar(64) DEFAULT NULL,
  `chemistry_num` varchar(64) DEFAULT NULL,
  `physics_num` varchar(64) DEFAULT NULL,
  `eligible_subjects` varchar(64) DEFAULT NULL,
  `total_points` varchar(64) DEFAULT NULL,
  `average` varchar(64) DEFAULT NULL,
  `class_level` varchar(64) DEFAULT NULL,
  `school_level` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6039 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sch_result_db`
-- ----------------------------
BEGIN;
INSERT INTO `sch_result_db` VALUES ('6028', '学籍号', '考号', '班级', '姓名', '数学', '语文', '汉语', '政治', '历史', '地理', '生物', '化学', '物理', '合格科目数', '总分', '平均分', '班级等级', '全校等级'), ('6029', 'L652924199805250036', '20167101', '9年级1班', '凯赛尔·阿卜力克木', '4', '90', '9', '48', '20', '', '', '78', '50', '1', '10', '20', '30', '50'), ('6030', 'L652924199808070073', '20167102', '9年级1班', '苏力坦·麦麦提尼亚孜', '17', '26', '4', '33', '14', '', '', '86', '78', '=COUNTIF(F3:N3,\">=60\")', '=SUM(F3:N3)', '=AVERAGE(F3:N3)', '=RANK(Q3,$Q$2:$Q$11)', '=RANK(Q3,$Q$2:$Q$11)'), ('6031', 'L652924199911130054', '20167103', '9年级1班', '希尔艾力·艾麦尔', '5', '28', '10', '20', '18', '', '', '56', '90', '=COUNTIF(F4:N4,\">=60\")', '=SUM(F4:N4)', '=AVERAGE(F4:N4)', '=RANK(Q4,$Q$2:$Q$11)', '40'), ('6032', 'L652924200001030148', '20167104', '9年级1班', '古丽拜克热木·赛买提', '49.5', '69', '15', '60', '35', '', '', '67', '78', '=COUNTIF(F5:N5,\">=60\")', '=SUM(F5:N5)', '=AVERAGE(F5:N5)', '=RANK(Q5,$Q$2:$Q$11)', '=RANK(Q5,$Q$2:$Q$11)'), ('6033', 'L652924200005160070', '20167105', '9年级1班', '麦吾兰·艾则孜', '28', '39', '15', '13', '14', '', '', '98', '23', '=COUNTIF(F6:N6,\">=60\")', '=SUM(F6:N6)', '=AVERAGE(F6:N6)', '=RANK(Q6,$Q$2:$Q$11)', '=RANK(Q6,$Q$2:$Q$11)'), ('6034', 'L652924200012180213', '20167106', '9年级1班', '苏来曼·托合尼亚孜', '40', '60', '14', '44', '35', '', '', '90', '34', '=COUNTIF(F7:N7,\">=60\")', '=SUM(F7:N7)', '=AVERAGE(F7:N7)', '=RANK(Q7,$Q$2:$Q$11)', '=RANK(Q7,$Q$2:$Q$11)'), ('6035', 'L652924200102010250', '20167107', '9年级1班', '比拉力·如则', '16', '44', '10', '32', '12', '', '', '34', '56', '=COUNTIF(F8:N8,\">=60\")', '=SUM(F8:N8)', '=AVERAGE(F8:N8)', '=RANK(Q8,$Q$2:$Q$11)', '=RANK(Q8,$Q$2:$Q$11)'), ('6036', 'L652924200103060129', '20167108', '9年级1班', '故再丽努尔·图尔贡', '23', '57.5', '31.5', '50', '20', '', '', '65', '65', '=COUNTIF(F9:N9,\">=60\")', '=SUM(F9:N9)', '=AVERAGE(F9:N9)', '=RANK(Q9,$Q$2:$Q$11)', '=RANK(Q9,$Q$2:$Q$11)'), ('6037', 'L652924200103210107', '20167109', '9年级1班', '热比古丽·海力力', '33', '32', '13', '47', '14', '', '', '56', '56', '=COUNTIF(F10:N10,\">=60\")', '=SUM(F10:N10)', '=AVERAGE(F10:N10)', '=RANK(Q10,$Q$2:$Q$11)', '=RANK(Q10,$Q$2:$Q$11)'), ('6038', 'L652924200103250061', '20167110', '9年级1班', '谢伊代·艾合买提', '20.5', '60', '5', '49', '16', '', '', '76', '76', '=COUNTIF(F11:N11,\">=60\")', '=SUM(F11:N11)', '=AVERAGE(F11:N11)', '=RANK(Q11,$Q$2:$Q$11)', '=RANK(Q11,$Q$2:$Q$11)');
COMMIT;

-- ----------------------------
--  Table structure for `sch_role`
-- ----------------------------
DROP TABLE IF EXISTS `sch_role`;
CREATE TABLE `sch_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `pid` int(10) DEFAULT NULL,
  `status` int(10) DEFAULT NULL,
  `remark` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sch_role`
-- ----------------------------
BEGIN;
INSERT INTO `sch_role` VALUES ('10', 'master', null, '1', '总管理员'), ('13', 'Content_manager', null, '1', '内容管理员'), ('14', 'Replay', null, '1', '留言管理员'), ('15', 'Manager', null, '1', '副管理员'), ('16', 'Category_manager', null, '1', '栏目管理员'), ('17', 'member_manager', null, '1', '会员管理员'), ('18', 'link_manager', null, '1', '友情链接管理员'), ('19', 'report_manager', null, '1', '成绩管理员'), ('20', 'administrator_manager', null, '1', '管理员管理'), ('21', 'visitor', null, '1', '旅客'), ('31', 'sinaq', null, '1', 'sinaq');
COMMIT;

-- ----------------------------
--  Table structure for `sch_role_user`
-- ----------------------------
DROP TABLE IF EXISTS `sch_role_user`;
CREATE TABLE `sch_role_user` (
  `role_id` int(10) NOT NULL,
  `user_id` char(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `sch_role_user`
-- ----------------------------
BEGIN;
INSERT INTO `sch_role_user` VALUES ('0', '2'), ('1', '4'), ('4', '5'), ('3', '6'), ('0', '7'), ('0', '8'), ('1', '9'), ('1', '10'), ('5', '11'), ('5', '12'), ('1', '12'), ('5', '13'), ('10', '14'), ('10', '15'), ('10', '16'), ('10', '17'), ('10', '18'), ('10', '19'), ('10', '20'), ('0', '20'), ('0', '21'), ('0', '22'), ('10', '23'), ('10', '24'), ('14', '25'), ('13', '25'), ('15', '26'), ('16', '26'), ('20', '27'), ('13', '28'), ('19', '29'), ('18', '30'), ('0', '31'), ('21', '32'), ('15', '33'), ('16', '34'), ('10', '35'), ('10', '36'), ('10', '37'), ('14', '38'), ('17', '38'), ('21', '39'), ('13', '39'), ('31', '40');
COMMIT;

-- ----------------------------
--  Table structure for `sch_student_info`
-- ----------------------------
DROP TABLE IF EXISTS `sch_student_info`;
CREATE TABLE `sch_student_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_number` varchar(64) DEFAULT NULL,
  `test_number` int(11) DEFAULT NULL,
  `class` varchar(64) DEFAULT NULL,
  `student_name` varchar(64) DEFAULT NULL,
  `subject` varchar(64) DEFAULT NULL,
  `result` int(3) DEFAULT NULL,
  `school_year` varchar(32) DEFAULT NULL,
  `term` int(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5147 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sch_student_info`
-- ----------------------------
BEGIN;
INSERT INTO `sch_student_info` VALUES ('5077', 'L652924199805250036', '20167101', '9年级1班', '凯赛尔·阿卜力克木', '数学', '40', '2015-2016', '1'), ('5078', 'L652924199805250036', '20167101', '9年级1班', '凯赛尔·阿卜力克木', '语文', '90', '2015-2016', '1'), ('5079', 'L652924199805250036', '20167101', '9年级1班', '凯赛尔·阿卜力克木', '汉语', '90', '2015-2016', '1'), ('5080', 'L652924199805250036', '20167101', '9年级1班', '凯赛尔·阿卜力克木', '政治', '48', '2015-2016', '1'), ('5081', 'L652924199805250036', '20167101', '9年级1班', '凯赛尔·阿卜力克木', '历史', '20', '2015-2016', '1'), ('5082', 'L652924199805250036', '20167101', '9年级1班', '凯赛尔·阿卜力克木', '化学', '78', '2015-2016', '1'), ('5083', 'L652924199805250036', '20167101', '9年级1班', '凯赛尔·阿卜力克木', '物理', '50', '2015-2016', '1'), ('5084', 'L652924199808070073', '20167102', '9年级1班', '苏力坦·麦麦提尼亚孜', '数学', '17', '2015-2016', '1'), ('5085', 'L652924199808070073', '20167102', '9年级1班', '苏力坦·麦麦提尼亚孜', '语文', '26', '2015-2016', '1'), ('5086', 'L652924199808070073', '20167102', '9年级1班', '苏力坦·麦麦提尼亚孜', '汉语', '4', '2015-2016', '1'), ('5087', 'L652924199808070073', '20167102', '9年级1班', '苏力坦·麦麦提尼亚孜', '政治', '33', '2015-2016', '1'), ('5088', 'L652924199808070073', '20167102', '9年级1班', '苏力坦·麦麦提尼亚孜', '历史', '14', '2015-2016', '1'), ('5089', 'L652924199808070073', '20167102', '9年级1班', '苏力坦·麦麦提尼亚孜', '化学', '86', '2015-2016', '1'), ('5090', 'L652924199808070073', '20167102', '9年级1班', '苏力坦·麦麦提尼亚孜', '物理', '78', '2015-2016', '1'), ('5091', 'L652924199911130054', '20167103', '9年级1班', '希尔艾力·艾麦尔', '数学', '5', '2015-2016', '1'), ('5092', 'L652924199911130054', '20167103', '9年级1班', '希尔艾力·艾麦尔', '语文', '28', '2015-2016', '1'), ('5093', 'L652924199911130054', '20167103', '9年级1班', '希尔艾力·艾麦尔', '汉语', '10', '2015-2016', '1'), ('5094', 'L652924199911130054', '20167103', '9年级1班', '希尔艾力·艾麦尔', '政治', '20', '2015-2016', '1'), ('5095', 'L652924199911130054', '20167103', '9年级1班', '希尔艾力·艾麦尔', '历史', '18', '2015-2016', '1'), ('5096', 'L652924199911130054', '20167103', '9年级1班', '希尔艾力·艾麦尔', '化学', '56', '2015-2016', '1'), ('5097', 'L652924199911130054', '20167103', '9年级1班', '希尔艾力·艾麦尔', '物理', '90', '2015-2016', '1'), ('5098', 'L652924200001030148', '20167104', '9年级1班', '古丽拜克热木·赛买提', '数学', '49', '2015-2016', '1'), ('5099', 'L652924200001030148', '20167104', '9年级1班', '古丽拜克热木·赛买提', '语文', '69', '2015-2016', '1'), ('5100', 'L652924200001030148', '20167104', '9年级1班', '古丽拜克热木·赛买提', '汉语', '15', '2015-2016', '1'), ('5101', 'L652924200001030148', '20167104', '9年级1班', '古丽拜克热木·赛买提', '政治', '60', '2015-2016', '1'), ('5102', 'L652924200001030148', '20167104', '9年级1班', '古丽拜克热木·赛买提', '历史', '35', '2015-2016', '1'), ('5103', 'L652924200001030148', '20167104', '9年级1班', '古丽拜克热木·赛买提', '化学', '67', '2015-2016', '1'), ('5104', 'L652924200001030148', '20167104', '9年级1班', '古丽拜克热木·赛买提', '物理', '78', '2015-2016', '1'), ('5105', 'L652924200005160070', '20167105', '9年级1班', '麦吾兰·艾则孜', '数学', '28', '2015-2016', '1'), ('5106', 'L652924200005160070', '20167105', '9年级1班', '麦吾兰·艾则孜', '语文', '39', '2015-2016', '1'), ('5107', 'L652924200005160070', '20167105', '9年级1班', '麦吾兰·艾则孜', '汉语', '15', '2015-2016', '1'), ('5108', 'L652924200005160070', '20167105', '9年级1班', '麦吾兰·艾则孜', '政治', '13', '2015-2016', '1'), ('5109', 'L652924200005160070', '20167105', '9年级1班', '麦吾兰·艾则孜', '历史', '14', '2015-2016', '1'), ('5110', 'L652924200005160070', '20167105', '9年级1班', '麦吾兰·艾则孜', '化学', '98', '2015-2016', '1'), ('5111', 'L652924200005160070', '20167105', '9年级1班', '麦吾兰·艾则孜', '物理', '23', '2015-2016', '1'), ('5112', 'L652924200012180213', '20167106', '9年级1班', '苏来曼·托合尼亚孜', '数学', '40', '2015-2016', '1'), ('5113', 'L652924200012180213', '20167106', '9年级1班', '苏来曼·托合尼亚孜', '语文', '60', '2015-2016', '1'), ('5114', 'L652924200012180213', '20167106', '9年级1班', '苏来曼·托合尼亚孜', '汉语', '14', '2015-2016', '1'), ('5115', 'L652924200012180213', '20167106', '9年级1班', '苏来曼·托合尼亚孜', '政治', '44', '2015-2016', '1'), ('5116', 'L652924200012180213', '20167106', '9年级1班', '苏来曼·托合尼亚孜', '历史', '35', '2015-2016', '1'), ('5117', 'L652924200012180213', '20167106', '9年级1班', '苏来曼·托合尼亚孜', '化学', '90', '2015-2016', '1'), ('5118', 'L652924200012180213', '20167106', '9年级1班', '苏来曼·托合尼亚孜', '物理', '34', '2015-2016', '1'), ('5119', 'L652924200102010250', '20167107', '9年级1班', '比拉力·如则', '数学', '16', '2015-2016', '1'), ('5120', 'L652924200102010250', '20167107', '9年级1班', '比拉力·如则', '语文', '44', '2015-2016', '1'), ('5121', 'L652924200102010250', '20167107', '9年级1班', '比拉力·如则', '汉语', '10', '2015-2016', '1'), ('5122', 'L652924200102010250', '20167107', '9年级1班', '比拉力·如则', '政治', '32', '2015-2016', '1'), ('5123', 'L652924200102010250', '20167107', '9年级1班', '比拉力·如则', '历史', '12', '2015-2016', '1'), ('5124', 'L652924200102010250', '20167107', '9年级1班', '比拉力·如则', '化学', '34', '2015-2016', '1'), ('5125', 'L652924200102010250', '20167107', '9年级1班', '比拉力·如则', '物理', '56', '2015-2016', '1'), ('5126', 'L652924200103060129', '20167108', '9年级1班', '故再丽努尔·图尔贡', '数学', '23', '2015-2016', '1'), ('5127', 'L652924200103060129', '20167108', '9年级1班', '故再丽努尔·图尔贡', '语文', '57', '2015-2016', '1'), ('5128', 'L652924200103060129', '20167108', '9年级1班', '故再丽努尔·图尔贡', '汉语', '31', '2015-2016', '1'), ('5129', 'L652924200103060129', '20167108', '9年级1班', '故再丽努尔·图尔贡', '政治', '50', '2015-2016', '1'), ('5130', 'L652924200103060129', '20167108', '9年级1班', '故再丽努尔·图尔贡', '历史', '20', '2015-2016', '1'), ('5131', 'L652924200103060129', '20167108', '9年级1班', '故再丽努尔·图尔贡', '化学', '65', '2015-2016', '1'), ('5132', 'L652924200103060129', '20167108', '9年级1班', '故再丽努尔·图尔贡', '物理', '65', '2015-2016', '1'), ('5133', 'L652924200103210107', '20167109', '9年级1班', '热比古丽·海力力', '数学', '33', '2015-2016', '1'), ('5134', 'L652924200103210107', '20167109', '9年级1班', '热比古丽·海力力', '语文', '32', '2015-2016', '1'), ('5135', 'L652924200103210107', '20167109', '9年级1班', '热比古丽·海力力', '汉语', '13', '2015-2016', '1'), ('5136', 'L652924200103210107', '20167109', '9年级1班', '热比古丽·海力力', '政治', '47', '2015-2016', '1'), ('5137', 'L652924200103210107', '20167109', '9年级1班', '热比古丽·海力力', '历史', '14', '2015-2016', '1'), ('5138', 'L652924200103210107', '20167109', '9年级1班', '热比古丽·海力力', '化学', '56', '2015-2016', '1'), ('5139', 'L652924200103210107', '20167109', '9年级1班', '热比古丽·海力力', '物理', '56', '2015-2016', '1'), ('5140', 'L652924200103250061', '20167110', '9年级1班', '谢伊代·艾合买提', '数学', '20', '2015-2016', '1'), ('5141', 'L652924200103250061', '20167110', '9年级1班', '谢伊代·艾合买提', '语文', '60', '2015-2016', '1'), ('5142', 'L652924200103250061', '20167110', '9年级1班', '谢伊代·艾合买提', '汉语', '5', '2015-2016', '1'), ('5143', 'L652924200103250061', '20167110', '9年级1班', '谢伊代·艾合买提', '政治', '49', '2015-2016', '1'), ('5144', 'L652924200103250061', '20167110', '9年级1班', '谢伊代·艾合买提', '历史', '16', '2015-2016', '1'), ('5145', 'L652924200103250061', '20167110', '9年级1班', '谢伊代·艾合买提', '化学', '76', '2015-2016', '1'), ('5146', 'L652924200103250061', '20167110', '9年级1班', '谢伊代·艾合买提', '物理', '76', '2015-2016', '1');
COMMIT;

-- ----------------------------
--  Table structure for `sch_user`
-- ----------------------------
DROP TABLE IF EXISTS `sch_user`;
CREATE TABLE `sch_user` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL,
  `password` varchar(33) NOT NULL,
  `loginip` varchar(15) NOT NULL,
  `logintime` int(11) NOT NULL,
  `lock` int(10) NOT NULL,
  `realname` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sch_user`
-- ----------------------------
BEGIN;
INSERT INTO `sch_user` VALUES ('37', 'admin', '21232f297a57a5a743894a0e4a801fc3', '0.0.0.0', '1441256353', '0', 'admin', null, null), ('32', 'visitor', '127870930d65c57ee65fcc47f2170d38', '0.0.0.0', '1439956579', '0', 'visitor', null, null), ('40', 'muzappar', '4297f44b13955235245b2497399d7a93', '0.0.0.0', '1442027975', '0', 'muzappar', null, null), ('36', 'ghulam', 'f691d2e02b9fba535b691392d886902c', '0.0.0.0', '1442483460', '0', 'ghulam', '222', '222');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
